<div class="span6 ">

<?php
require_once("koneksi.php");

$sementara = mysql_query("SELECT * FROM cari_sementara WHERE id_cari = '1'");
$cari = mysql_fetch_array($sementara);
$jenis = $cari['jenis_cari'];
$kota_kabupaten = $cari['kota_kabupaten_cari'];
$propinsi_id = $cari['propinsi_id'];
$fasilitas1 = $cari['fasilitas1_cari'];
$fasilitas2 = $cari['fasilitas2_cari'];
$fasilitas3 = $cari['fasilitas3_cari'];
$fasilitas4 = $cari['fasilitas4_cari'];

$query = mysql_query("SELECT * FROM Iklan NATURAL JOIN kota_kabupaten NATURAL JOIN propinsi WHERE jenis = '$jenis' and kota_kabupaten = '$kota_kabupaten' AND propinsi_id = '$propinsi_id' and fasilitas1 = '$fasilitas1' and fasilitas2 = '$fasilitas2' and fasilitas3 = '$fasilitas3' and fasilitas4 = '$fasilitas4'");
$jumlah = mysql_num_rows($query);

if($jumlah == 0) 
{
	 	include "tidakadaiklan.php";
}
else
{
	 while ($hasil1 = mysql_fetch_assoc($query))
	 	{include "adaiklan.php";}

}
?>


</div><!-- End .span6 -->